Complete Excel 2010 Video Tutorial in English
(EB4)
Duration: 340 MB
SYLLABUS:Ms-Excel VIDEO TUTORIAL 2010 1. Home
2. Conditional Formatting
3. Alignment, Wrap Text
4. Insert Date, Week Days and Months
5. Pivot Table and Chart
6. FORMULAS
7. Rectify Errors
8. FUNCTION
9. Percentage, Comparison
10. Create Mark sheet
ADVANCE EXCEL VIDEO TUTORIAL 2010
1. Converting, Auto sum
2. Vlookup
3. Choose, Index, Match
4. Count if, Sum if, Average if
5. Rank, Median, Average
6. Date, Weekday, Workday
7. Array and Frequency
8. Data Extract Left Right
9. Concatenate, Replace, Substitute
10. PMT, FV
11. Is Function
12. Offset, Data Extract
FORMULAS OF EXCEL 2010
1. Count, Count blank, Count if
2. Dated if, Average, Abs
3. Edate, Length
4. Powers, Ran between
5. Repeat, Find
6. Roman, Small
7. Round, Fixed
8. Sum product, Large, And
9. Time, Trim, Year
|